Table Definition - File Structure

You can either define the file structure in the script manually or you can use the Table Definition wizard to aid you.

The Table Definition scripts contain the definitions for each of the fields in a table. The name of the Table Definition script is defined in the Control Script associated with the table to be loaded.

The file will contain entries in the following format:

TABLE =

The full database and table name on which the data load is to take place.

SOURCETABLE =

Used by ODBC to identify the input table and allow ODBC to connect.

KEY =

The unique key in the table used for updating records. It should be supplied as just the short field name. .

TABLE =

The full database and table name on which the data load is to take place.

The TABLE_DEFINITION section is structured as follows:

FIELDNAME

The short name of the field to be created or updated in the given table.

FIELD TYPE

Use one of the available Engine field types.

If you want the fields to be fully indexed:

If you do not wish a field to be indexed, declare the field type with an upper case 'U' preceding it:

OFFSET or ORDINAL

If the data file is FLAT, the zero based offset of the field should be supplied. If the data file is DELIMITED, the zero based ordinal of each field should be supplied.

WIDTH

For all fields, the actual maximum width of the field should be supplied.

FORMAT

(Optional) If the field is defined as Date or Time, you must specify the date format using CC,YY,MM,DD in the appropriate combination, with additional characters if required. The time field must be defined using HH,MM,SS.

For example, "CCYY MM DD", "HH MM SS"

For a format of "01JAN2001" the format used should be "FREE".

DEFAULT

(Optional) Indicates the value used instead of NULL when the field input data is empty. If you wish to use a default value and no format is required, you must insert a blank value for Format. For example, OCCUPATION,TEXT,0,10,"","NA".

Points to Note

Some data extracts represent a Null value for a REAL data type as a decimal point. iLoader interprets this as a zero value and creates the field with a value of zero instead of null (0.0).

For REAL data types, an explicit decimal point and precision of two decimal places is the default. You may change the precision by specifying this in the FORMAT column. iLoader supports precision of up to six decimal places. Precision = (a number ranging from 0 to 6).

Array fields can be loaded by selecting a TEXT field and giving it a format. An associated decode file can be optionally added.

• Editing Scripts
  • Using The iLoader Editing Tools
  • Using the Table Declaration Wizard
  • Table Declaration File Structure
  • Table Declaration Example
  • Using the Table Definition Wizard
  • Table Definition File Structure
  • Table Definition Example
  • Indexing Fields
  • Creating Scripts Manually